GrapeCity.CalcEngine.Functions Namespace > CalcIndexFunction Class > Evaluate Method : Evaluate(Object[]) Method |
The args contains 2 - 4 items: array, row_num, [column_num], [Area_num].
Array is a range of cells or an array constant.
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
[Column_num] selects the column in array from which to return a value. If column_num is omitted, row_num is required.
[Area_num] selects a range in reference from which to return the intersection of row_num and column_num.'Declaration Public Overloads Overrides Function Evaluate( _ ByVal args() As System.Object _ ) As System.Object
'Usage Dim instance As CalcIndexFunction Dim args() As System.Object Dim value As System.Object value = instance.Evaluate(args)
public override System.object Evaluate( System.object[] args )
The args contains 2 - 4 items: array, row_num, [column_num], [Area_num].
Array is a range of cells or an array constant.
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
[Column_num] selects the column in array from which to return a value. If column_num is omitted, row_num is required.
[Area_num] selects a range in reference from which to return the intersection of row_num and column_num.Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)